約 3,864,824 件
https://w.atwiki.jp/cocoareferencejp/pages/118.html
Tags ガイド 未完 言語 Cocoa トップ ガイド ブロックプログラミング概論 前のページ? ブロックと変数 翻訳元 この記事ではブロックと変数間の内部的な働きをメモリ管理も含めて説明します。 このページの最終更新:2010-05-12 ADCの最終更新:2009-10-19 目次 変数の型(Types of Variable) __block ストレージ型(The __block Storage Type) オブジェクトとブロック変数 Objecive-Cオブジェクト 変数の型(Types of Variable) ブロックオブジェクトのコードの集合では、変数は五つの異なる形で扱われます。 三つの標準的な変数の型は関数内と全く同様に参照することができます。 グローバル変数。静的変数を含む。 グローバル関数(厳密には変数ではない)。 スコープに囲まれたローカル変数とパラメータ。 またブロックは他に二つの変数の型をサポートしています。 [At function level are __block variables.]これらはブロック(とスコープ)内で変更可能で、参照されているどんなブロックがヒープにコピーされても保護されます。 constの取り込み 最後に、メソッドの実装中ではブロックはObjective-Cインスタンス変数を参照できます。「オブジェクトとブロック変数(Object and Block Variables)」を参照してください。 ブロック中で使用される変数には以下の規則が適用されます。 グローバル変数とレキシカルスコープ中に存在する静的変数はアクセス可能です。 ブロックに渡されたパラメータ(ちょうど関数の引数のように)はアクセス可能です。 レキシカルスコープに囲まれた局所的なスタック(静的でない)変数はconst変数として切り取られます。この変数はプログラム中でブロック表現にさしかかった時に取得されます。ネストされたブロックでは、この値は最も近いスコープから切り取られます。 レキシカルスコープ中で__blockストレージ型修飾子で宣言された変数は参照で提供されるので変更可能になります。そのレキシカルスコープ中での変更は同じスコープで宣言された他のブロックのも含め全て反映されます。これらは「__block ストレージ型(The __block Storage Type)」で詳説しています。 ブロック中のレキシカルスコープ中で宣言されたローカル変数は関数中のローカル変数と全く同じように働きます。ブロックの呼び出しではそれぞれこの変数の新しいコピーが作られます。これらの変数はブロック中のブロックでconstや参照変数として代わる代わる使うことができます。 以下の例では静的でないローカル変数の用法を説明しています。 int x = 123;void (^printXAndY)(int) = ^(int y) {printf("%d %d\n", x, y);};printXAndY(456); // prints 123 456 注意してほしいのは、ブロック中でxで新しい値を参照しようとするとエラーになることです。 int x = 123;void (^printXAndY)(int) = ^(int y) {x = x + y; // errorprintf("%d %d\n", x, y);}; 変数をブロック中で変更できるようにするには、__blockストレージ型修飾子を使用します。「__block ストレージ型(The __block Storage Type)」をご覧ください。 __block ストレージ型(The __block Storage Type) __block型修飾子を適用することによって読み込んだ変数を変更可能であること、つまり読み書き可能であることを明示できます。__blockストレージ型はローカル変数を修飾するregister、auto、staticストレージ型と似ていますが、同時に使うことはできません。 __block変数はその変数のレキシカルスコープと、その中で生成または宣言された全てのブロックとその複製で共有されるストレージに確保されます。したがって、スタックフレームが破棄されても(例えば後で実行する為にどこかに待機させることで)、その中で宣言されたブロックの複製が生存していれば、ストレージは決して破棄されません。一つのレキシカルスコープ中の複数のブロックは共有する変数を同時に使うことがあります。 最適化の為に、ブロックストレージはブロック自体と同じようにまずスタック外に確保されます。もしブロックがBlock_copyを使って(またはObjective-Cでブロックにcopyを送って)コピーされれば、変数はヒープにコピーされます。つまり、__block変数のアドレスは時間とともに変わることがあります。 __block変数にはもう二つの制限があり、可変長の配列がなること、C99可変長配列を含む構造体がなることはできません。 以下の例では__block変数の用法を説明しています。 __block int x = 123; // xはブロックストレージ中に確保されるvoid (^printXAndY)(int) = ^(int y) {x = x + y;printf("%d %d\n", x, y);};printXAndY(456); // prints 579 456// 今xは579 以下の例ではいくつかの異なる型の変数とブロック間の相互作用を示しています。 extern NSInteger CounterGlobal;static NSInteger CounterStatic;;{NSInteger localCounter = 42;__block char localCharacter;void (^aBlock)(void) = ^(void) {++CounterGlobal;++CounterStatic;CounterGlobal = localCounter; // localCounter fixed at block creationlocalCharacter = 'a'; // sets localCharacter in enclosing scope};++localCounter; // unseen by the blocklocalCharacter = 'b';aBlock(); // execute the block// localCharacter now 'a'} オブジェクトとブロック変数 ブロックはObjective-CとC++のオブジェクトや別ブロックへのサポートを変数という形で提供しています。 Objecive-Cオブジェクト リファレンスカウンタ環境下では、ブロック中でObjective-Cオブジェクトを参照するときには通常そのオブジェクトを保持します。これはオブジェクトのインスタンス変数を単純に参照する場合でも当てはまります。ですが、__blockストレージ型修飾子のついたオブジェクト変数は保持されません。 注:ガベージコレクタ環境下では、__weak修飾子や__block修飾子を変数に適用した場合、そのブロックではその変数が確保されていることを保証できません。 ブロックをメソッドの実装内で使用した場合、オブジェクトインスタンス変数のメモリ管理の規則はさらに巧妙になります。 インスタンス変数に参照でアクセスしている場合には、selfが保持されます。 インスタンス変数に値でアクセスしている場合には、その変数が保持されます。 以下の例ではこの異なる二つの状況を説明しています。 dispatch_async(queue, ^{// instanceVariableは参照なのでselfが保持されますdoSomethingWithObject(instanceVariable);});id localVariable = instanceVariable;dispatch_async(queue, ^{// localVariableは値なので、localVariableが保持されます(selfではありません)doSomethingWithObject(localVariable);}); 前のページ 次のページ ?
https://w.atwiki.jp/mainichi-matome/pages/2076.html
Bloggerjrocknyc 関連ページ Blogger https //www.blogger.com/ jrocknyc http //jrocknyc.blogspot.com/ 部分転載 an elaborate code used by a schoolgirl prostitute ring cops broke up this week http //jrocknyc.blogspot.com/2008/02/elaborate-code-used-by-schoolgirl.html "Tabloid Tidbits Schoolgirl sex sellers use codes for carnality" From the government ministry that brought you Pearl Harbor and the Rape of Nanking... http //jrocknyc.blogspot.com/2007/07/from-government-ministry-that-brought.html "Defense Ministry turns to Lolita manga character to reveal inner self" Rubik s Cube sex peddled as latest cure for Japan s bedroom bashfuls http //jrocknyc.blogspot.com/2007/07/rubiks-cube-sex-peddled-as-latest-cure.html Arrogant and dumb hacks slam Miss Universe Riyo Mori http //jrocknyc.blogspot.com/2007/07/arrogant-and-dumb-hacks-slam-miss.html "Arrogant and dumb Local celeb hacks slam Miss Universe Riyo Mori" Transvestite troubadour a sucker for the tall, possessive type http //jrocknyc.blogspot.com/2006/12/transvestite-troubadour-sucker-for_10.html "Transvestite troubadour a sucker for the tall, possessive type" "Deadly iku iku byo reaches a climax" "Elite Todai co-ed gets cherry popped on camera" "Japan s latest titillating trend Hiding those huge hooters!" Kabukicho Roppongi "News" http //jrocknyc.blogspot.com/2006/11/kabukicho-roppongi-news.html "Sexy soul sisters shine in Shinjuku" The world and Japan look at each other, to see who blinks first http //jrocknyc.blogspot.com/2006/11/world-and-japan-look-at-each-other-to.html Surefire ways to lure the ladies (Just don t mention the Love Hotel ) http //jrocknyc.blogspot.com/2006/11/surefire-ways-to-lure-ladies-just-dont.html Terrorist paradise Japan needs its own CIA http //jrocknyc.blogspot.com/2006/09/terrorist-paradise-japan-needs-its-own.html Skeletons under the floorboards? Mum s the word for Japanese realtors http //jrocknyc.blogspot.com/2006/08/skeletons-under-floorboards-mums-word.html Akihabara s Hokoshatengoku Crackdown! http //jrocknyc.blogspot.com/2006/07/akihabaras-hokoshatengoku-crackdown.html "Long arm of the Tokyo law wrestles with Akihabara s street geeks" "kids... they don t like the feel of cold hard steel on their butts." http //jrocknyc.blogspot.com/2006/07/kids-they-dont-like-feel-of-cold-hard.html "One, two, poo in your shoe; three, four, wee on the floor" Sensin.net http //jrocknyc.blogspot.com/2006/07/sensinnet.html "Bogus Buddhist seeks sweetie, gains enlightenment instead" Avoid a fornication fatality with the medics guide to post-coital first aid http //jrocknyc.blogspot.com/2006/06/avoid-fornication-fatality-with-medics.html Sex workers on the ball with World Cup fever http //jrocknyc.blogspot.com/2006/06/sex-workers-on-ball-with-world-cup.html Politicians crack down on Love Hotel Hill, but can t stop the love http //jrocknyc.blogspot.com/2006/05/politicians-crack-down-on-love-hotel.html Sex! http //jrocknyc.blogspot.com/2006/04/sex.html "Spring romance goes high tech with the latest condom goodies" Bondage master Arisue not yet at the end of his rope http //jrocknyc.blogspot.com/2006/04/bondage-master-arisue-not-yet-at-end.html Bonk buddies? (lol, "journalism") http //jrocknyc.blogspot.com/2006/02/bonk-buddies-lol-journalism.html "Bonk buddies? Damned if they did, damned if they didn t" Kids superhero getting bum rap over gay porn film http //jrocknyc.blogspot.com/2006/02/kids-superhero-getting-bum-rap-over.html Lengthy King Kong remake fails to scale to Empire State Building heights http //jrocknyc.blogspot.com/2006/01/lengthy-king-kong-remake-fails-to.html A Partner Swapping Variety Show http //jrocknyc.blogspot.com/2005/11/partner-swapping-variety-show.html "Reality TV Japan-style Trade in your husband for a young hunk" See, Studying the Japanese Language *Can* Be Fun! http //jrocknyc.blogspot.com/2005/06/see-studying-japanese-language-can-be.html "Just between us girls -- the secret slang splurted in the ejaculation industry" Tsutsutomase, the name given to beautiful women criminals http //jrocknyc.blogspot.com/2005/06/tsutsutomase-name-given-to-beautiful.html "Hard line on hardcore leaves crack open for femme fatales" 関連ページ Blogger Bogus Buddhist seeks sweetie, gains enlightenment instead Deadly 'iku iku byo' reaches a climax Defense Ministry turns to 'Lolita' manga character to reveal inner self Japan's latest titillating trend Hiding those huge hooters! One, Two, Poo in Your Shoe; Three, Four, Wee on the Floor Sex workers on the ball with World Cup fever Spring romance goes high tech with the latest condom goodies Tabloid Tidbits Schoolgirl sex sellers use codes for carnality
https://w.atwiki.jp/rupt/pages/173.html
drops for Ruputer ../ ソフトウェア名 drops for Ruputer 現Version 1.0 作者(敬称略) wiz. 配布元 こめっこのホームページ Ruputerこの辺り ソフトウェア形態 ? ソース 非公開 紹介 6種類の宝石を縦横斜に3つ並べて消す落ち物ゲーム。連鎖もできるよ。 稀に降ってくる珍しい宝石には特殊な効果があるらしい。 スクリーンショットから見て分かる通り、Ruputerを縦にしてプレイする。 (スクリーンショット情報) 全:Aurex2 RC4 + WinShot ver1.53a
https://w.atwiki.jp/keisks/pages/149.html
ざっくばらんに集めてみます。 入門UNIXシェルプログラミング―シェルの基礎から学ぶUNIXの世界 指定した範囲の行を取得 http //p.tl/fwu9 Unix-for-Poets http //www.stanford.edu/class/cs124/kwc-unix-for-poets.pdf Natural Language Processing Using Linux http //www.generation5.org/content/2004/nlpUnix.asp Command line tools for NLP and Machine Learning http //www.drmaciver.com/2009/04/command-line-tools-for-nlp-and-machine-learning/ Advanced Bash-Scripting Guide 16.4. Text Processing Commands http //tldp.org/LDP/abs/html/textproc.html Linux コマンド テキスト処理 コマンド 一覧 http //www.webhtm.net/unix/cmd/cmd_list_text.htm cut, sort, uniq で生産性を5%向上させる http //blog.bonar.jp/entry/20070618/1182183655 Linuxコマンドでテキストデータを自在に操る http //d.hatena.ne.jp/mi_kattun/20100916/1284631280 特定の行を見たい。 sed -n #p FILENAME #=行番号(1からカウント) pythonでは昔書いたこちらが使えます。 指定した範囲の行 sed -n 開始行,終了行p ファイル名 ファイルの分割 http //www.k-tanaka.net/unix/split.html split -b 100k file1 #file1を100KBごとに分割 split -l 1000 file2 #file2を1000行ずつに分割 split -b 1m file* test #名前がfileで始まるファイルを1MBごとに分割し、ファイル名の頭にtestを付ける xargs http //www.nxmnpg.com/ja/1/xargs 明示的に並列化する場合は、-P オプションをつけます。(e.g. -P16) e.g. find . -name "*.xml" | xargs -i% -P16 cp % %.txt 上の例は簡単な処理ですが、splitで分割したファイルを並列でparseする場合などは便利です。 comm http //www.k-tanaka.net/unix/comm.html 評価の時に使えそうですね。 comm (option) [file name] (file name) オプション 機能 -1 左列を出力しない -2 中央列を出力しない -3 右列を出力しない -12 右列のみ出力する -13 中央列のみ出力する -23 左列のみ出力する コマンド例 comm file1 file2 file1とfile2を比較して差異を表示 comm -12 file1 file2 両方のファイルに共通して存在する行を表示 エラー分析にも使えそう。 omm A B -23 |sort | uniq -c | sort -nr A-BでAにしかないエラーでランキング。 service 周り (sudo) service httpd start // web server をオンにする (sudo) service iptables stop // firewall をオフにする (sudo) chkconfig httpd on // httpdをrestartしたあともオンにする find コマンドをフル活用 特に\( \), -not, -o -wholename オプションは使える。 http //qiita.com/catfist/items/5504511fa5a028fc7c41 http //d.hatena.ne.jp/mrgoofy33/20100823/1282576209 ワンライナーで。wsjの02-21ディレクトリにあるのmrgファイルをすべてfindするとか?
https://w.atwiki.jp/hypixeljp/pages/326.html
9/7日より、アップデートでJaxという矢を販売するNPCが追加された。 アップデート情報についてはこちら https //hypixel.net/threads/september-7th-weaponsmith-city-project.4530741/ 目次 場所 Jaxについて Jaxのクエストのやり方 候補地 NPCで交換できる特殊矢についてArrow Swapper Flint Arrow 64本 Reinforced Iron Arrow 64本 Gold-tipped Arrow 64本 Redstone-tipped Arrow Emerald-tipped Arrow 64本 Bouncy Arrow 64本 Icy Arrow 64本 Armorshred Arrow 64本 Explosive Arrow 64本 Glue Arrow Nansorb Arrow 64本 場所 スポーンして奥の建物の地下にいます。 Jaxについて Jaxに話しかけると、 Hello [Name] What brings you to my workshop? I forge the newest and most powerful arrows in all of skyblock! If you can prove to me you re a real archer I ll forge you arrows whenerver you need them. Ready to test your skills? step on the pressure plate and all the targets will light up, if you can shoot them all in 25 seconds, I ll know you re the real deal. 翻訳すると以下のようになります。 こんにちは[名前] 私のワークショップに何を持ってきたの? スカイブロックのすべてで最新かつ最も強力な矢を作ります! 本当のArcherであることを私に証明することができれば、必要とするときはいつでも矢を製造します。 スキルをテストする準備はできましたか? 鉄プレートを踏むと、すべてのターゲットが点灯します。25秒ですべてを撃つことができれば、あなたが本物だとわかります。 Jaxのクエストのやり方 ①弓と矢を用意します。 ②○で囲んでいるところを踏むと、3秒間のカウントダウンが始まります。 カウントダウンが終わると25秒間以内にランタンを弓で打つ必要があります。 候補地 左側7個 中心4個 右側3個 NPC側2個 NPCで交換できる特殊矢について Arrow Swapper Quiver(矢筒)で優先して使用する矢の種類を選択できます。 選択済み:なし 左クリック:前の矢 右クリック:次の矢 コスト 1,000コイン Flint Arrow 64本 通常の矢。 コスト 3,200コイン Reinforced Iron Arrow 64本 必要なスキルレベル Combatレベル4以上 コスト 鉄インゴットx24個 Gold-tipped Arrow 64本 必要なスキルレベル Combatレベル8以上 コスト 金インゴットx40個 Redstone-tipped Arrow 必要なスキルレベル Combatレベル13以上 コスト レッドストーンブロックx24個 Emerald-tipped Arrow 64本 必要なスキルレベル Combatレベル18以上 コスト エメラルドブロックx16個 Bouncy Arrow 64本 矢の効果 矢は50%の確率で別のターゲットに跳ね返り 4ターゲットまで跳ね返り、各跳ね返りでは15%少ないダメージを与える。 必要なスキルレベル Combatレベル20以上 Slime(スライム)コレクションが7以上である必要がある。 コスト スライムブロックx24個 Icy Arrow 64本 矢の効果 移動速度低下(Slowness) I を3秒間ターゲットに付与する。 必要なスキルレベル Combatレベル21以上 Ice(氷)コレクションが7以上である必要がある。 コスト Packed Ice x64個 Armorshred Arrow 64本 矢の効果 ターゲットのDefenseの5%を無視してダメージを与える。 必要なスキルレベル Combatレベル22以上 Sand(砂)コレクションが7以上である必要がある。 コスト エンチャントされた砂ブロック(Enchanted Sand) x2個 Explosive Arrow 64本 矢の効果 この矢は2秒後に衝撃で爆発します。 爆発は矢のダメージを2.5ブロック以内のMobに当たります 爆発に巻き込まれると、あなたの体力の10%が削られます。 必要なスキルレベル Combatレベル23以上 Coal(石炭)コレクションが7以上である必要がある。 コスト 石炭ブロック x24個 Glue Arrow 矢の効果 攻撃を受けたときに被害者が1.5秒間歩くのを防ぎます。 必要なスキルレベル Combatレベル24以上 Spiderスレイヤーが3以上である必要がある。 コスト Tarantula Web x64個 Nansorb Arrow 64本 矢の効果 PiercingエンチャントをSkewerのダメージ軽減に置き換えます。 パッシブスキル Skewer Piercingによるヒットダメージは、前のものより+7.5%のダメージを与えます。 最大5人まで可能。 必要なスキルレベル Combatレベル25以上 Cactus(サボテン)コレクションが7以上である必要がある。 コスト エンチャントされた緑色の染料(Enchanted Cactus Green) x8個
https://w.atwiki.jp/handover/pages/36.html
Hiro has been in charge of financial system for many years, but it turned out to be transferred to overseas with the next personnel change. Successor Kei is a mid-level employee, but she has never developed or operated the some system by herself. How should we explain the work content to successors who are less experienced than ourselves? If Hiro premise Kei the same capabilities as himself and omit the detailed explanation, Kei might not understand the knowledge at all. Kei is aware of her less experience and knowledge. During the handover period, she is trying to understand the knowledge of Hiro firmly. The time for handover is firmly secured. Nurture the successor carefully and instruct it over time. Hiro explained politely the financial system based on the recognition that he will be a teacher for Kei during the handover period. Kei was able to understand the basics of the financial system and was able to acquire firmly about expalined knowledge. At the end of the handover, she grew up well as Hiro s successor. In the case where the Successor as capable as the predecessor or Mercenary is executed, it is not necessary to execute this pattern. It takes time to do this pattern, so it is necessary to do it when time is secured by Timing of appointment and Intention for responsible handover. However, if you need to do this pattern without enough time, there is a danger that it will not fit within the handover period. So you need to supplement by Extra-ining for completion of the handover.
https://w.atwiki.jp/akatonbowiki/pages/6901.html
このページはこちらに移転しました for ever 作詞/257スレ244 乾燥している空の下を完走 今年が終わる来年への駆け出し 紅白見終え煩悩数え 鳴らぬ携帯電話携帯して そのまま初詣一人で願掛け 「今年も作曲スレの皆が元気でありますように」と
https://w.atwiki.jp/hmiku/pages/17344.html
なっしんぐれふとふぉーみー【登録タグ N あえりあ 巡音ルカ 曲】 作詞:あえりあ 作曲:あえりあ 編曲:あえりあ 唄:巡音ルカ 曲紹介 あえりあにとっては初のVOCALOIDオリジナル楽曲。その前に般若心経メタルコアを作っていたことは別に秘密でもなんでもない。 今作は英語ルカの上にメタルコア作品に仕上がっている。 イラストと動画をWeatherH、エンコードをDEATH姫が担当。 歌詞 (歌詞カードより転載) fraud. that the world is slowly ending, and someday there will be no humans. but if it's true, then what are we living for? it must be far to painful, living a miserable life in a world filled with despair. I seemed that I had somehow fallen into the sea of worthlessness Or perhaps I had never even taken off to begin with I could'nt shut my eyes from that reality i can't found mine. the meaning to my being here and now there's nothing left for me. i don't want them to suffer like i did I may be trying to atone. trying to atone. days full of happiness that i never noticed. i have lost that time, You will walk this life as how ever unchanging. the impulse that was moving me forward is disappearing. The sky is falling me down. Ask forgiveness as this little white. And I remember to close my eyes gently. Landscape and I, gradually dyed. We are in the bed, Repeat the blunder of the past recall. Than necessary, like self-mutilation. If I was not me at that time I bet me will fail and allowed. But it's not absolutely. never born again, myself. i wish i could rebuild my lives. but it's Foolish delusion. Don't involving people in my mistake. I never born again. I just wish my pulse stopped buried in snow. 歌詞の日本語訳 偽り 世界はゆっくりと終わりに近づいていて、 いつの日か人類は滅びるだろう。 だがもしそれが本当なら、 私たちは何の為に生きているの? こんな残りカスの世界、絶望の中で哀れに生きるなんて淋しいだろう。 私はどうやら不毛の海へと落ちてしまったらしい いや、最初から飛び立ってさえいなかったかもしれん その事実に目をつむってはならぬ そして私は見つけられなかった。 私がここにいる意味を。 そして俺にはもう何も残されていない。 彼らには私のような思いをさせたくない。 私は罪滅ぼししようとした。 罪滅ぼしを。 気づかないままに終わってしまった俺の満たされていた日々。 俺はその時間を失ってしまった。 あなたはまた今と変わらぬ人生を歩むことだろう 私を衝き動かしていた物が消えていく。 空が私へと落ちてくる。 この小さな白に許しを乞う。 そして私は静かに目を閉じて思い出す。 風景と私は少しずつ染められていく。 私たちはベットの中で、 過去の失態を繰り返し思い出す。 必要以上に、自傷的に。 あの時の私が私でなかったならば、 きっとあの失敗を許したでしょう。 だけどそれは絶対にない事。 私よ、もう生まれてこないでください。 私は人生をやり直すことを望んでいました。 だけどそれは愚かな妄想なのです。 私の過ちで人を巻き込んではいけないのです。 もう生まれてこないよ。 雪に埋れて私の脈が止まってくれたら良い。 コメント こういう曲が埋もれるのは悲しい。もっと評価されないかなぁ。 -- 名無しさん (2013-02-12 22 58 03) 名前 コメント
https://w.atwiki.jp/tounderlinedk/pages/22.html
Fantastic cooking -2- Look for Legendary food ≪△≫ (Japanese) I m in the cave. Bats beat me. My hands and feet are benumbed. And I advance. Lyric (japanese language) Access of the artists Basic Information This is our 5th music. Japanese title is "すごい料理 第2楽章 ~ 伝説の食材". StyleRock Singerone of Miku Hatsune PerformerMiku Hatsune Rin Kagamine Len Kagamine MEIKO CollaborationAll illustrations by piapro.jp users. 1st appearanceJuly 20, 2008 on zoome.jp Publish on Web on YouTube on Dailymotion 作品解説 on zoomeon メーカー未公認jamバンドファンクラブ(zoome) on TDKI(zoome) Tags Work Main works6. Stop picking on my sister (Rap) 5. Fantastic cooking -2- Look for Legendary food (Rock) 4. Meet (Rock) 3. Germination, a matter of sun and death (Rock) 2. want to say, to telephon-chan (Rap) 1. Fair, before thunder(Children s song) WorkSearch by Singer Search by Performer Date Order WelcomeAbout Exhibition space Work LinksSearch Japanese Version page view( - ) Copyright ©2008-2009 to_dk.
https://w.atwiki.jp/rds4oracle/pages/4.html
SQL set pages 1000SQL /ORIGINATING_TIMESTAMP MESSAGE_TEXT-------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------25-SEP-13 05.28.42.300 AM +00 00 Starting ORACLE instance (restrict)25-SEP-13 05.28.42.707 AM +00 00 LICENSE_MAX_SESSION = 025-SEP-13 05.28.42.707 AM +00 00 LICENSE_SESSIONS_WARNING = 025-SEP-13 05.28.42.799 AM +00 00 Picked latch-free SCN scheme 325-SEP-13 05.28.42.952 AM +00 00 Autotune of undo retention is turned on.25-SEP-13 05.28.42.956 AM +00 00 IMODE=BR25-SEP-13 05.28.42.956 AM +00 00 ILAT =1025-SEP-13 05.28.43.021 AM +00 00 LICENSE_MAX_USERS = 025-SEP-13 05.28.43.022 AM +00 00 SYS auditing is disabled25-SEP-13 05.28.43.197 AM +00 00 Starting up 25-SEP-13 05.28.43.197 AM +00 00 Oracle Database 11g Release 11.2.0.2.0 - 64bit Production.25-SEP-13 05.28.43.197 AM +00 00 Using parameter settings in server-side spfile /rdsdbbin/oracle/dbs/spfileORCL.ora25-SEP-13 05.28.43.197 AM +00 00 WARNING there are one or more recursive spfile references which should be removed from /rdsdbbin/oracle/dbs/spfileORCL.ora25-SEP-13 05.28.43.198 AM +00 00 System parameters with non-default values 25-SEP-13 05.28.43.198 AM +00 00 processes = 4425-SEP-13 05.28.43.198 AM +00 00 spfile = /rdsdbbin/oracle/dbs/spfileORCL.ora 25-SEP-13 05.28.43.198 AM +00 00 filesystemio_options = setall 25-SEP-13 05.28.43.198 AM +00 00 memory_target = 312M25-SEP-13 05.28.43.198 AM +00 00 memory_max_target = 312M25-SEP-13 05.28.43.198 AM +00 00 control_files = /rdsdbdata/db/ORCL_A/controlfile/control-01.ctl 25-SEP-13 05.28.43.198 AM +00 00 log_archive_dest_1 = location= /rdsdbdata/db/ORCL_A/arch/redolog , valid_for=(ALL_LOGFILES,ALL_ROLES) 25-SEP-13 05.28.43.198 AM +00 00 log_archive_format = -%s-%t-%r.arc 25-SEP-13 05.28.43.199 AM +00 00 archive_lag_target = 30025-SEP-13 05.28.43.199 AM +00 00 db_create_file_dest = /rdsdbdata/db 25-SEP-13 05.28.43.199 AM +00 00 db_recovery_file_dest_size= 1G25-SEP-13 05.28.43.199 AM +00 00 standby_file_management = AUTO 25-SEP-13 05.28.43.199 AM +00 00 undo_tablespace = UNDO_T1 25-SEP-13 05.28.43.199 AM +00 00 db_block_checking = MEDIUM 25-SEP-13 05.28.43.199 AM +00 00 recyclebin = OFF 25-SEP-13 05.28.43.199 AM +00 00 local_listener = (ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) 25-SEP-13 05.28.43.199 AM +00 00 audit_file_dest = /rdsdbdata/admin/ORCL/adump 25-SEP-13 05.28.43.199 AM +00 00 db_name = ORCL 25-SEP-13 05.28.43.200 AM +00 00 db_unique_name = ORCL_A 25-SEP-13 05.28.43.200 AM +00 00 open_cursors = 30025-SEP-13 05.28.43.200 AM +00 00 dg_broker_config_file1 = /rdsdbdata/config/dr1ORCL.dat 25-SEP-13 05.28.43.200 AM +00 00 dg_broker_config_file2 = /rdsdbdata/config/dr2ORCL.dat 25-SEP-13 05.28.43.200 AM +00 00 diagnostic_dest = /rdsdbdata/log 25-SEP-13 05.28.45.206 AM +00 00 PSP0 started with pid=3, OS id=254225-SEP-13 05.28.45.209 AM +00 00 PMON started with pid=2, OS id=254025-SEP-13 05.28.45.298 AM +00 00 GEN0 started with pid=5, OS id=254825-SEP-13 05.28.45.324 AM +00 00 DIAG started with pid=6, OS id=255025-SEP-13 05.28.45.351 AM +00 00 DBRM started with pid=7, OS id=255225-SEP-13 05.28.45.376 AM +00 00 DIA0 started with pid=8, OS id=255425-SEP-13 05.28.45.402 AM +00 00 MMAN started with pid=9, OS id=255625-SEP-13 05.28.45.438 AM +00 00 DBW0 started with pid=10, OS id=255825-SEP-13 05.28.45.464 AM +00 00 LGWR started with pid=11, OS id=256025-SEP-13 05.28.45.489 AM +00 00 CKPT started with pid=12, OS id=256225-SEP-13 05.28.45.506 AM +00 00 VKTM started with pid=4, OS id=254425-SEP-13 05.28.45.508 AM +00 00 VKTM running at (100ms) precision25-SEP-13 05.28.45.517 AM +00 00 SMON started with pid=13, OS id=256425-SEP-13 05.28.45.543 AM +00 00 RECO started with pid=14, OS id=256625-SEP-13 05.28.45.571 AM +00 00 MMON started with pid=15, OS id=256825-SEP-13 05.28.45.603 AM +00 00 ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment25-SEP-13 05.28.45.705 AM +00 00 MMNL started with pid=16, OS id=257025-SEP-13 05.28.45.715 AM +00 00 Spfile /rdsdbbin/oracle/dbs/spfileORCL.ora is in old pre-11 format and compatible = 11.0.0; converting to new H.A.R.D. compliant format.25-SEP-13 05.28.46.755 AM +00 00 ALTER DATABASE MOUNT25-SEP-13 05.28.50.889 AM +00 00 Successful mount of redo thread 1, with mount id 135481332625-SEP-13 05.28.50.893 AM +00 00 Database mounted in Exclusive Mode25-SEP-13 05.28.50.894 AM +00 00 Lost write protection disabled25-SEP-13 05.28.50.977 AM +00 00 Create Relation IPS_PACKAGE_UNPACK_HISTORY25-SEP-13 05.28.51.203 AM +00 00 Completed ALTER DATABASE MOUNT25-SEP-13 05.28.51.253 AM +00 00 ALTER DATABASE OPEN25-SEP-13 05.28.52.518 AM +00 00 Thread 1 opened at log sequence 725-SEP-13 05.28.52.518 AM +00 00 Current log# 1 seq# 7 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 05.28.52.518 AM +00 00 Successful open of redo thread 125-SEP-13 05.28.52.534 AM +00 00 SMON enabling cache recovery25-SEP-13 05.28.53.136 AM +00 00 [2602] Successfully onlined Undo Tablespace 2.25-SEP-13 05.28.53.136 AM +00 00 Undo initialization finished serial 0 start 1147096 end 1147496 diff 400 (4 seconds)25-SEP-13 05.28.53.137 AM +00 00 Verifying file header compatibility for 11g tablespace encryption..25-SEP-13 05.28.53.137 AM +00 00 Verifying 11g file header compatibility for tablespace encryption completed25-SEP-13 05.28.53.138 AM +00 00 SMON enabling tx recovery25-SEP-13 05.28.53.172 AM +00 00 Re-creating tempfile /rdsdbdata/db/ORCL_A/datafile/o1_mf_temp_8zjx60sh_.tmp as /rdsdbdata/db/ORCL_A/datafile/o1_mf_temp_944x4o4x_.tmp25-SEP-13 05.28.53.460 AM +00 00 Database Characterset is US7ASCII25-SEP-13 05.28.53.564 AM +00 00 No Resource Manager plan active25-SEP-13 05.28.53.702 AM +00 00 replication_dependency_tracking turned off (no async multimaster replication found)25-SEP-13 05.28.54.071 AM +00 00 Starting background process QMNC25-SEP-13 05.28.54.096 AM +00 00 QMNC started with pid=18, OS id=261725-SEP-13 05.28.54.555 AM +00 00 Completed ALTER DATABASE OPEN25-SEP-13 05.28.54.595 AM +00 00 Starting background process CJQ025-SEP-13 05.28.54.621 AM +00 00 CJQ0 started with pid=17, OS id=262625-SEP-13 05.28.54.917 AM +00 00 alter database end backup25-SEP-13 05.28.54.945 AM +00 00 WARNING datafile #1 was not in online backup mode25-SEP-13 05.28.54.945 AM +00 00 WARNING datafile #2 was not in online backup mode25-SEP-13 05.28.54.946 AM +00 00 WARNING datafile #3 was not in online backup mode25-SEP-13 05.28.54.946 AM +00 00 WARNING datafile #4 was not in online backup mode25-SEP-13 05.28.54.946 AM +00 00 WARNING datafile #5 was not in online backup mode25-SEP-13 05.28.54.954 AM +00 00 ORA-1142 signalled during alter database end backup...25-SEP-13 05.28.59.225 AM +00 00 ALTER DATABASE CHARACTER SET INTERNAL_CONVERT AL32UTF825-SEP-13 05.29.03.418 AM +00 00 Updating character set in controlfile to AL32UTF825-SEP-13 05.29.03.461 AM +00 00 Synchronizing connection with database character set information25-SEP-13 05.29.05.244 AM +00 00 SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered25-SEP-13 05.29.05.264 AM +00 00 SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered25-SEP-13 05.29.05.317 AM +00 00 SYS.RULE$ (CONDITION) - CLOB representation altered25-SEP-13 05.29.05.325 AM +00 00 SYS.SCHEDULER$_EVENT_LOG (ADDITIONAL_INFO) - CLOB representation altered25-SEP-13 05.29.05.487 AM +00 00 SYS.WRI$_REPT_FILES (SYS_NC00005$) - CLOB representation altered25-SEP-13 05.29.05.547 AM +00 00 SYS.WRI$_ADV_OBJECTS (ATTR4) - CLOB representation altered25-SEP-13 05.29.05.548 AM +00 00 SYS.WRI$_ADV_OBJECTS (OTHER) - CLOB representation altered25-SEP-13 05.29.05.618 AM +00 00 SYS.WRI$_ADV_DIRECTIVE_META (DATA) - CLOB representation altered25-SEP-13 05.29.06.125 AM +00 00 SYS.WRI$_DBU_FEATURE_METADATA (INST_CHK_LOGIC) - CLOB representation altered25-SEP-13 05.29.06.166 AM +00 00 SYS.WRI$_DBU_FEATURE_METADATA (USG_DET_LOGIC) - CLOB representation altered25-SEP-13 05.29.06.185 AM +00 00 SYS.WRI$_DBU_FEATURE_USAGE (FEATURE_INFO) - CLOB representation altered25-SEP-13 05.29.06.199 AM +00 00 SYS.WRI$_DBU_HWM_METADATA (LOGIC) - CLOB representation altered25-SEP-13 05.29.06.917 AM +00 00 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY (EXPRESSION) - CLOB representation altered25-SEP-13 05.29.06.958 AM +00 00 SYS.ATTRIBUTE_TRANSFORMATIONS$ (XSL_TRANSFORMATION) - CLOB representation altered25-SEP-13 05.29.06.979 AM +00 00 SYS.AUD$ (SQLBIND) - CLOB representation altered25-SEP-13 05.29.06.981 AM +00 00 SYS.AUD$ (SQLTEXT) - CLOB representation altered25-SEP-13 05.29.07.257 AM +00 00 Refreshing type attributes with new character set information25-SEP-13 05.29.09.036 AM +00 00 Completed ALTER DATABASE CHARACTER SET INTERNAL_CONVERT AL32UTF825-SEP-13 05.29.09.833 AM +00 00 SERVER COMPONENT id=UTLRP_BGN timestamp=2013-09-25 05 29 0925-SEP-13 05.29.29.792 AM +00 00 SERVER COMPONENT id=UTLRP_END timestamp=2013-09-25 05 29 2925-SEP-13 05.29.39.265 AM +00 00 ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY;25-SEP-13 05.29.39.268 AM +00 00 Stopping background process CJQ025-SEP-13 05.29.39.270 AM +00 00 Stopping background process QMNC25-SEP-13 05.29.40.293 AM +00 00 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;25-SEP-13 05.29.40.295 AM +00 00 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;25-SEP-13 05.29.40.307 AM +00 00 Shutting down instance (immediate)25-SEP-13 05.29.40.325 AM +00 00 Shutting down instance further logons disabled25-SEP-13 05.29.42.992 AM +00 00 Stopping background process MMNL25-SEP-13 05.29.43.993 AM +00 00 Stopping background process MMON25-SEP-13 05.29.45.012 AM +00 00 License high water mark = 325-SEP-13 05.29.45.093 AM +00 00 ALTER DATABASE CLOSE NORMAL25-SEP-13 05.29.45.230 AM +00 00 SMON disabling tx recovery25-SEP-13 05.29.46.298 AM +00 00 SMON disabling cache recovery25-SEP-13 05.29.46.367 AM +00 00 Shutting down archive processes25-SEP-13 05.29.46.367 AM +00 00 Archiving is disabled25-SEP-13 05.29.46.368 AM +00 00 Archive process shutdown avoided 0 active25-SEP-13 05.29.46.370 AM +00 00 Thread 1 closed at log sequence 725-SEP-13 05.29.46.378 AM +00 00 Successful close of redo thread 125-SEP-13 05.29.46.399 AM +00 00 Completed ALTER DATABASE CLOSE NORMAL25-SEP-13 05.29.46.401 AM +00 00 ALTER DATABASE DISMOUNT25-SEP-13 05.29.46.401 AM +00 00 Shutting down archive processes25-SEP-13 05.29.46.402 AM +00 00 Archiving is disabled25-SEP-13 05.29.46.441 AM +00 00 Completed ALTER DATABASE DISMOUNT25-SEP-13 05.29.46.457 AM +00 00 ARCH Archival disabled due to shutdown 108925-SEP-13 05.29.46.460 AM +00 00 Shutting down archive processes25-SEP-13 05.29.46.460 AM +00 00 Archiving is disabled25-SEP-13 05.29.47.465 AM +00 00 ARCH Archival disabled due to shutdown 108925-SEP-13 05.29.47.465 AM +00 00 Shutting down archive processes25-SEP-13 05.29.47.466 AM +00 00 Archiving is disabled25-SEP-13 05.29.47.557 AM +00 00 Stopping background process VKTM25-SEP-13 05.29.51.393 AM +00 00 Instance shutdown complete25-SEP-13 05.30.03.714 AM +00 00 Starting ORACLE instance (normal)25-SEP-13 05.30.04.229 AM +00 00 LICENSE_MAX_SESSION = 025-SEP-13 05.30.04.229 AM +00 00 LICENSE_SESSIONS_WARNING = 025-SEP-13 05.30.04.385 AM +00 00 Picked latch-free SCN scheme 325-SEP-13 05.30.04.593 AM +00 00 Autotune of undo retention is turned on.25-SEP-13 05.30.04.595 AM +00 00 IMODE=BR25-SEP-13 05.30.04.595 AM +00 00 ILAT =1025-SEP-13 05.30.04.622 AM +00 00 LICENSE_MAX_USERS = 025-SEP-13 05.30.04.622 AM +00 00 SYS auditing is disabled25-SEP-13 05.30.04.827 AM +00 00 Starting up 25-SEP-13 05.30.04.827 AM +00 00 Oracle Database 11g Release 11.2.0.2.0 - 64bit Production.25-SEP-13 05.30.04.828 AM +00 00 Using parameter settings in server-side spfile /rdsdbbin/oracle/dbs/spfileORCL.ora25-SEP-13 05.30.04.828 AM +00 00 WARNING there are one or more recursive spfile references which should be removed from /rdsdbbin/oracle/dbs/spfileORCL.ora25-SEP-13 05.30.04.828 AM +00 00 System parameters with non-default values 25-SEP-13 05.30.04.828 AM +00 00 processes = 4425-SEP-13 05.30.04.828 AM +00 00 spfile = /rdsdbbin/oracle/dbs/spfileORCL.ora 25-SEP-13 05.30.04.828 AM +00 00 filesystemio_options = setall 25-SEP-13 05.30.04.828 AM +00 00 memory_target = 312M25-SEP-13 05.30.04.828 AM +00 00 memory_max_target = 312M25-SEP-13 05.30.04.829 AM +00 00 control_files = /rdsdbdata/db/ORCL_A/controlfile/control-01.ctl 25-SEP-13 05.30.04.829 AM +00 00 log_archive_dest_1 = location= /rdsdbdata/db/ORCL_A/arch/redolog , valid_for=(ALL_LOGFILES,ALL_ROLES) 25-SEP-13 05.30.04.829 AM +00 00 log_archive_format = -%s-%t-%r.arc 25-SEP-13 05.30.04.829 AM +00 00 archive_lag_target = 30025-SEP-13 05.30.04.829 AM +00 00 db_create_file_dest = /rdsdbdata/db 25-SEP-13 05.30.04.829 AM +00 00 db_recovery_file_dest_size= 1G25-SEP-13 05.30.04.829 AM +00 00 standby_file_management = AUTO 25-SEP-13 05.30.04.830 AM +00 00 undo_tablespace = UNDO_T1 25-SEP-13 05.30.04.830 AM +00 00 db_block_checking = MEDIUM 25-SEP-13 05.30.04.830 AM +00 00 recyclebin = OFF 25-SEP-13 05.30.04.830 AM +00 00 local_listener = (ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) 25-SEP-13 05.30.04.830 AM +00 00 audit_file_dest = /rdsdbdata/admin/ORCL/adump 25-SEP-13 05.30.04.830 AM +00 00 db_name = ORCL 25-SEP-13 05.30.04.831 AM +00 00 db_unique_name = ORCL_A 25-SEP-13 05.30.04.831 AM +00 00 open_cursors = 30025-SEP-13 05.30.04.831 AM +00 00 dg_broker_config_file1 = /rdsdbdata/config/dr1ORCL.dat 25-SEP-13 05.30.04.831 AM +00 00 dg_broker_config_file2 = /rdsdbdata/config/dr2ORCL.dat 25-SEP-13 05.30.04.831 AM +00 00 diagnostic_dest = /rdsdbdata/log 25-SEP-13 05.30.05.003 AM +00 00 PSP0 started with pid=3, OS id=303225-SEP-13 05.30.05.006 AM +00 00 PMON started with pid=2, OS id=303025-SEP-13 05.30.05.054 AM +00 00 VKTM started with pid=4, OS id=303425-SEP-13 05.30.05.057 AM +00 00 VKTM running at (100ms) precision25-SEP-13 05.30.05.085 AM +00 00 GEN0 started with pid=5, OS id=303825-SEP-13 05.30.05.115 AM +00 00 DIAG started with pid=6, OS id=304025-SEP-13 05.30.05.144 AM +00 00 DBRM started with pid=7, OS id=304225-SEP-13 05.30.05.172 AM +00 00 DIA0 started with pid=8, OS id=304425-SEP-13 05.30.05.198 AM +00 00 MMAN started with pid=9, OS id=304625-SEP-13 05.30.05.230 AM +00 00 DBW0 started with pid=10, OS id=304825-SEP-13 05.30.05.257 AM +00 00 LGWR started with pid=11, OS id=305025-SEP-13 05.30.05.283 AM +00 00 CKPT started with pid=12, OS id=305225-SEP-13 05.30.05.309 AM +00 00 SMON started with pid=13, OS id=305425-SEP-13 05.30.05.336 AM +00 00 RECO started with pid=14, OS id=305625-SEP-13 05.30.05.363 AM +00 00 MMON started with pid=15, OS id=305825-SEP-13 05.30.05.396 AM +00 00 ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment25-SEP-13 05.30.05.694 AM +00 00 ALTER DATABASE MOUNT25-SEP-13 05.30.05.725 AM +00 00 MMNL started with pid=16, OS id=306025-SEP-13 05.30.05.730 AM +00 00 Spfile /rdsdbbin/oracle/dbs/spfileORCL.ora is in old pre-11 format and compatible = 11.0.0; converting to new H.A.R.D. compliant format.25-SEP-13 05.30.09.913 AM +00 00 Successful mount of redo thread 1, with mount id 135482159725-SEP-13 05.30.09.916 AM +00 00 Database mounted in Exclusive Mode25-SEP-13 05.30.09.916 AM +00 00 Lost write protection disabled25-SEP-13 05.30.10.055 AM +00 00 Completed ALTER DATABASE MOUNT25-SEP-13 05.30.10.511 AM +00 00 alter database end backup25-SEP-13 05.30.10.536 AM +00 00 ORA-1142 signalled during alter database end backup...25-SEP-13 05.30.11.454 AM +00 00 alter database archivelog25-SEP-13 05.30.11.473 AM +00 00 Completed alter database archivelog25-SEP-13 05.30.11.947 AM +00 00 alter database open25-SEP-13 05.30.12.029 AM +00 00 LGWR STARTING ARCH PROCESSES25-SEP-13 05.30.12.054 AM +00 00 ARC0 started with pid=18, OS id=315425-SEP-13 05.30.12.061 AM +00 00 ARC0 Archival started25-SEP-13 05.30.12.061 AM +00 00 LGWR STARTING ARCH PROCESSES COMPLETE25-SEP-13 05.30.12.066 AM +00 00 ARC0 STARTING ARCH PROCESSES25-SEP-13 05.30.12.111 AM +00 00 ARC1 started with pid=19, OS id=315625-SEP-13 05.30.12.145 AM +00 00 Thread 1 opened at log sequence 725-SEP-13 05.30.12.145 AM +00 00 Current log# 1 seq# 7 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 05.30.12.146 AM +00 00 Successful open of redo thread 125-SEP-13 05.30.12.160 AM +00 00 ARC2 started with pid=20, OS id=315825-SEP-13 05.30.12.177 AM +00 00 ARC1 Archival started25-SEP-13 05.30.12.177 AM +00 00 ARC2 Archival started25-SEP-13 05.30.12.178 AM +00 00 ARC1 Becoming the no FAL ARCH25-SEP-13 05.30.12.178 AM +00 00 ARC1 Becoming the no SRL ARCH25-SEP-13 05.30.12.178 AM +00 00 ARC3 started with pid=21, OS id=316025-SEP-13 05.30.12.190 AM +00 00 ARC2 Becoming the heartbeat ARCH25-SEP-13 05.30.12.211 AM +00 00 SMON enabling cache recovery25-SEP-13 05.30.12.868 AM +00 00 [3152] Successfully onlined Undo Tablespace 2.25-SEP-13 05.30.12.868 AM +00 00 Undo initialization finished serial 0 start 1227016 end 1227226 diff 210 (2 seconds)25-SEP-13 05.30.12.869 AM +00 00 Verifying file header compatibility for 11g tablespace encryption..25-SEP-13 05.30.12.870 AM +00 00 Verifying 11g file header compatibility for tablespace encryption completed25-SEP-13 05.30.12.870 AM +00 00 SMON enabling tx recovery25-SEP-13 05.30.12.906 AM +00 00 Database Characterset is AL32UTF825-SEP-13 05.30.13.099 AM +00 00 No Resource Manager plan active25-SEP-13 05.30.13.425 AM +00 00 replication_dependency_tracking turned off (no async multimaster replication found)25-SEP-13 05.30.13.907 AM +00 00 ARC3 Archival started25-SEP-13 05.30.13.907 AM +00 00 ARC0 STARTING ARCH PROCESSES COMPLETE25-SEP-13 05.30.14.094 AM +00 00 Starting background process QMNC25-SEP-13 05.30.14.120 AM +00 00 QMNC started with pid=22, OS id=316925-SEP-13 05.30.14.612 AM +00 00 Completed alter database open25-SEP-13 05.30.16.329 AM +00 00 Starting background process CJQ025-SEP-13 05.30.16.462 AM +00 00 CJQ0 started with pid=17, OS id=321425-SEP-13 05.31.08.436 AM +00 00 Thread 1 advanced to log sequence 8 (LGWR switch)25-SEP-13 05.31.08.437 AM +00 00 Current log# 2 seq# 8 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 05.31.13.411 AM +00 00 Archived Log entry 1 added for thread 1 sequence 7 ID 0x4ffec4be dest 1 25-SEP-13 05.33.04.672 AM +00 00 alter database backup controlfile to /rdsdbdata/tmp/backup_control_file reuse25-SEP-13 05.33.05.583 AM +00 00 Completed alter database backup controlfile to /rdsdbdata/tmp/backup_control_file reuse25-SEP-13 05.33.05.605 AM +00 00 alter database begin backup25-SEP-13 05.33.05.944 AM +00 00 Completed alter database begin backup25-SEP-13 05.33.06.364 AM +00 00 alter database end backup25-SEP-13 05.33.06.954 AM +00 00 Completed alter database end backup25-SEP-13 05.36.10.352 AM +00 00 Thread 1 advanced to log sequence 9 (LGWR switch)25-SEP-13 05.36.10.352 AM +00 00 Current log# 3 seq# 9 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 05.36.10.578 AM +00 00 Archived Log entry 2 added for thread 1 sequence 8 ID 0x4ffec4be dest 1 25-SEP-13 05.40.02.559 AM +00 00 Starting background process SMCO25-SEP-13 05.40.02.600 AM +00 00 SMCO started with pid=24, OS id=393825-SEP-13 05.41.11.088 AM +00 00 Thread 1 advanced to log sequence 10 (LGWR switch)25-SEP-13 05.41.11.088 AM +00 00 Current log# 4 seq# 10 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 05.41.11.284 AM +00 00 Archived Log entry 3 added for thread 1 sequence 9 ID 0x4ffec4be dest 1 25-SEP-13 05.46.02.720 AM +00 00 Stopping background process CJQ025-SEP-13 05.46.08.938 AM +00 00 Thread 1 advanced to log sequence 11 (LGWR switch)25-SEP-13 05.46.08.938 AM +00 00 Current log# 1 seq# 11 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 05.46.09.046 AM +00 00 Archived Log entry 4 added for thread 1 sequence 10 ID 0x4ffec4be dest 1 25-SEP-13 05.51.09.986 AM +00 00 Thread 1 cannot allocate new log, sequence 1225-SEP-13 05.51.09.986 AM +00 00 Checkpoint not complete25-SEP-13 05.51.09.986 AM +00 00 Current log# 1 seq# 11 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 05.51.13.035 AM +00 00 Thread 1 advanced to log sequence 12 (LGWR switch)25-SEP-13 05.51.13.035 AM +00 00 Current log# 2 seq# 12 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 05.51.13.149 AM +00 00 Archived Log entry 5 added for thread 1 sequence 11 ID 0x4ffec4be dest 1 25-SEP-13 05.56.16.819 AM +00 00 Thread 1 cannot allocate new log, sequence 1325-SEP-13 05.56.16.820 AM +00 00 Checkpoint not complete25-SEP-13 05.56.16.820 AM +00 00 Current log# 2 seq# 12 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 05.56.19.888 AM +00 00 Thread 1 advanced to log sequence 13 (LGWR switch)25-SEP-13 05.56.19.888 AM +00 00 Current log# 3 seq# 13 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 05.56.19.960 AM +00 00 Archived Log entry 6 added for thread 1 sequence 12 ID 0x4ffec4be dest 1 25-SEP-13 06.01.21.070 AM +00 00 Thread 1 advanced to log sequence 14 (LGWR switch)25-SEP-13 06.01.21.071 AM +00 00 Current log# 4 seq# 14 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 06.01.22.062 AM +00 00 Archived Log entry 7 added for thread 1 sequence 13 ID 0x4ffec4be dest 1 25-SEP-13 06.06.22.046 AM +00 00 Thread 1 cannot allocate new log, sequence 1525-SEP-13 06.06.22.046 AM +00 00 Checkpoint not complete25-SEP-13 06.06.22.046 AM +00 00 Current log# 4 seq# 14 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 06.06.26.272 AM +00 00 Thread 1 advanced to log sequence 15 (LGWR switch)25-SEP-13 06.06.26.273 AM +00 00 Current log# 1 seq# 15 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 06.06.26.466 AM +00 00 Archived Log entry 8 added for thread 1 sequence 14 ID 0x4ffec4be dest 1 25-SEP-13 06.09.31.145 AM +00 00 ALTER SYSTEM RESET local_listener SCOPE=SPFILE SID= * ;25-SEP-13 06.09.31.308 AM +00 00 ALTER SYSTEM SET local_listener= (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) SCOPE=BOTH;25-SEP-13 06.11.27.379 AM +00 00 Thread 1 cannot allocate new log, sequence 1625-SEP-13 06.11.27.380 AM +00 00 Checkpoint not complete25-SEP-13 06.11.27.380 AM +00 00 Current log# 1 seq# 15 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 06.11.30.461 AM +00 00 Thread 1 advanced to log sequence 16 (LGWR switch)25-SEP-13 06.11.30.461 AM +00 00 Current log# 2 seq# 16 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 06.11.30.567 AM +00 00 Archived Log entry 9 added for thread 1 sequence 15 ID 0x4ffec4be dest 1 25-SEP-13 06.16.34.541 AM +00 00 Thread 1 cannot allocate new log, sequence 1725-SEP-13 06.16.34.541 AM +00 00 Checkpoint not complete25-SEP-13 06.16.34.542 AM +00 00 Current log# 2 seq# 16 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 06.16.37.591 AM +00 00 Thread 1 advanced to log sequence 17 (LGWR switch)25-SEP-13 06.16.37.592 AM +00 00 Current log# 3 seq# 17 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 06.16.37.689 AM +00 00 Archived Log entry 10 added for thread 1 sequence 16 ID 0x4ffec4be dest 1 25-SEP-13 06.19.36.824 AM +00 00 WARNING Granules of pga_aggregate_target 39 cannot be more than memory_target (78) - sga_target (0) or min_sga (40)25-SEP-13 06.21.38.843 AM +00 00 Thread 1 advanced to log sequence 18 (LGWR switch)25-SEP-13 06.21.38.843 AM +00 00 Current log# 4 seq# 18 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 06.21.38.931 AM +00 00 Archived Log entry 11 added for thread 1 sequence 17 ID 0x4ffec4be dest 1 25-SEP-13 06.26.40.104 AM +00 00 Thread 1 advanced to log sequence 19 (LGWR switch)25-SEP-13 06.26.40.104 AM +00 00 Current log# 1 seq# 19 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 06.26.40.210 AM +00 00 Archived Log entry 12 added for thread 1 sequence 18 ID 0x4ffec4be dest 1 25-SEP-13 06.27.42.144 AM +00 00 WARNING Granules of pga_aggregate_target 39 cannot be more than memory_target (78) - sga_target (0) or min_sga (40)25-SEP-13 06.31.41.003 AM +00 00 Thread 1 advanced to log sequence 20 (LGWR switch)25-SEP-13 06.31.41.030 AM +00 00 Current log# 2 seq# 20 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 06.31.41.157 AM +00 00 Archived Log entry 13 added for thread 1 sequence 19 ID 0x4ffec4be dest 1 25-SEP-13 06.35.46.516 AM +00 00 WARNING Granules of pga_aggregate_target 39 cannot be more than memory_target (78) - sga_target (0) or min_sga (40)25-SEP-13 06.36.39.652 AM +00 00 Thread 1 cannot allocate new log, sequence 2125-SEP-13 06.36.39.652 AM +00 00 Checkpoint not complete25-SEP-13 06.36.39.652 AM +00 00 Current log# 2 seq# 20 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 06.36.42.704 AM +00 00 Thread 1 advanced to log sequence 21 (LGWR switch)25-SEP-13 06.36.42.704 AM +00 00 Current log# 3 seq# 21 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 06.36.42.789 AM +00 00 Archived Log entry 14 added for thread 1 sequence 20 ID 0x4ffec4be dest 1 25-SEP-13 06.41.43.905 AM +00 00 Thread 1 cannot allocate new log, sequence 2225-SEP-13 06.41.43.906 AM +00 00 Checkpoint not complete25-SEP-13 06.41.43.906 AM +00 00 Current log# 3 seq# 21 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 06.41.46.957 AM +00 00 Thread 1 advanced to log sequence 22 (LGWR switch)25-SEP-13 06.41.46.957 AM +00 00 Current log# 4 seq# 22 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 06.41.47.103 AM +00 00 Archived Log entry 15 added for thread 1 sequence 21 ID 0x4ffec4be dest 1 25-SEP-13 06.46.51.070 AM +00 00 Thread 1 cannot allocate new log, sequence 2325-SEP-13 06.46.51.070 AM +00 00 Checkpoint not complete25-SEP-13 06.46.51.071 AM +00 00 Current log# 4 seq# 22 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 06.46.57.686 AM +00 00 Thread 1 advanced to log sequence 23 (LGWR switch)25-SEP-13 06.46.57.686 AM +00 00 Current log# 1 seq# 23 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 06.46.57.763 AM +00 00 Archived Log entry 16 added for thread 1 sequence 22 ID 0x4ffec4be dest 1 25-SEP-13 06.51.58.736 AM +00 00 Thread 1 advanced to log sequence 24 (LGWR switch)25-SEP-13 06.51.58.736 AM +00 00 Current log# 2 seq# 24 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 06.51.58.837 AM +00 00 Archived Log entry 17 added for thread 1 sequence 23 ID 0x4ffec4be dest 1 25-SEP-13 06.52.06.230 AM +00 00 WARNING Granules of pga_aggregate_target 39 cannot be more than memory_target (78) - sga_target (0) or min_sga (40)25-SEP-13 06.56.56.763 AM +00 00 Thread 1 cannot allocate new log, sequence 2525-SEP-13 06.56.56.763 AM +00 00 Checkpoint not complete25-SEP-13 06.56.56.763 AM +00 00 Current log# 2 seq# 24 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 06.57.00.748 AM +00 00 Thread 1 advanced to log sequence 25 (LGWR switch)25-SEP-13 06.57.00.748 AM +00 00 Current log# 3 seq# 25 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 06.57.00.826 AM +00 00 Archived Log entry 18 added for thread 1 sequence 24 ID 0x4ffec4be dest 1 25-SEP-13 07.02.04.898 AM +00 00 Thread 1 advanced to log sequence 26 (LGWR switch)25-SEP-13 07.02.04.898 AM +00 00 Current log# 4 seq# 26 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 07.02.05.076 AM +00 00 Archived Log entry 19 added for thread 1 sequence 25 ID 0x4ffec4be dest 1 25-SEP-13 07.02.09.449 AM +00 00 WARNING Granules of pga_aggregate_target 39 cannot be more than memory_target (78) - sga_target (0) or min_sga (40)25-SEP-13 07.07.08.908 AM +00 00 Thread 1 cannot allocate new log, sequence 2725-SEP-13 07.07.08.909 AM +00 00 Checkpoint not complete25-SEP-13 07.07.08.909 AM +00 00 Current log# 4 seq# 26 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 07.07.12.013 AM +00 00 Thread 1 advanced to log sequence 27 (LGWR switch)25-SEP-13 07.07.12.013 AM +00 00 Current log# 1 seq# 27 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 07.07.12.091 AM +00 00 Archived Log entry 20 added for thread 1 sequence 26 ID 0x4ffec4be dest 1 25-SEP-13 07.10.38.774 AM +00 00 Thread 1 advanced to log sequence 28 (LGWR switch)25-SEP-13 07.10.38.774 AM +00 00 Current log# 2 seq# 28 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 07.10.38.881 AM +00 00 Archived Log entry 21 added for thread 1 sequence 27 ID 0x4ffec4be dest 1 25-SEP-13 07.10.45.557 AM +00 00 Thread 1 cannot allocate new log, sequence 2925-SEP-13 07.10.45.557 AM +00 00 Checkpoint not complete25-SEP-13 07.10.45.558 AM +00 00 Current log# 2 seq# 28 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 07.10.51.563 AM +00 00 Thread 1 advanced to log sequence 29 (LGWR switch)25-SEP-13 07.10.51.563 AM +00 00 Current log# 3 seq# 29 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 07.10.51.630 AM +00 00 Archived Log entry 22 added for thread 1 sequence 28 ID 0x4ffec4be dest 1 25-SEP-13 07.10.55.654 AM +00 00 WARNING Granules of pga_aggregate_target 39 cannot be more than memory_target (78) - sga_target (0) or min_sga (40)25-SEP-13 07.11.02.364 AM +00 00 Thread 1 cannot allocate new log, sequence 3025-SEP-13 07.11.02.364 AM +00 00 Checkpoint not complete25-SEP-13 07.11.02.364 AM +00 00 Current log# 3 seq# 29 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 07.11.03.475 AM +00 00 Thread 1 advanced to log sequence 30 (LGWR switch)25-SEP-13 07.11.03.476 AM +00 00 Current log# 4 seq# 30 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 07.11.03.595 AM +00 00 Archived Log entry 23 added for thread 1 sequence 29 ID 0x4ffec4be dest 1 25-SEP-13 07.13.39.417 AM +00 00 Thread 1 advanced to log sequence 31 (LGWR switch)25-SEP-13 07.13.39.417 AM +00 00 Current log# 1 seq# 31 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 07.13.39.527 AM +00 00 Archived Log entry 24 added for thread 1 sequence 30 ID 0x4ffec4be dest 1 25-SEP-13 07.14.40.864 AM +00 00 alter database backup controlfile to /rdsdbdata/tmp/backup_control_file reuse25-SEP-13 07.14.41.875 AM +00 00 Completed alter database backup controlfile to /rdsdbdata/tmp/backup_control_file reuse25-SEP-13 07.14.41.879 AM +00 00 alter database begin backup25-SEP-13 07.14.42.838 AM +00 00 Completed alter database begin backup25-SEP-13 07.14.43.261 AM +00 00 alter database end backup25-SEP-13 07.14.44.260 AM +00 00 Completed alter database end backup25-SEP-13 07.18.40.609 AM +00 00 Thread 1 advanced to log sequence 32 (LGWR switch)25-SEP-13 07.18.40.609 AM +00 00 Current log# 2 seq# 32 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 07.18.40.684 AM +00 00 Archived Log entry 25 added for thread 1 sequence 31 ID 0x4ffec4be dest 1 25-SEP-13 07.23.38.787 AM +00 00 Thread 1 advanced to log sequence 33 (LGWR switch)25-SEP-13 07.23.38.787 AM +00 00 Current log# 3 seq# 33 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 07.23.38.873 AM +00 00 Archived Log entry 26 added for thread 1 sequence 32 ID 0x4ffec4be dest 1 25-SEP-13 07.28.39.662 AM +00 00 Thread 1 advanced to log sequence 34 (LGWR switch)25-SEP-13 07.28.39.662 AM +00 00 Current log# 4 seq# 34 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 07.28.39.718 AM +00 00 Archived Log entry 27 added for thread 1 sequence 33 ID 0x4ffec4be dest 1 25-SEP-13 07.33.40.532 AM +00 00 Thread 1 cannot allocate new log, sequence 3525-SEP-13 07.33.40.532 AM +00 00 Checkpoint not complete25-SEP-13 07.33.40.532 AM +00 00 Current log# 4 seq# 34 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 07.33.43.601 AM +00 00 Thread 1 advanced to log sequence 35 (LGWR switch)25-SEP-13 07.33.43.601 AM +00 00 Current log# 1 seq# 35 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 07.33.43.675 AM +00 00 Archived Log entry 28 added for thread 1 sequence 34 ID 0x4ffec4be dest 1 25-SEP-13 07.38.44.995 AM +00 00 Thread 1 cannot allocate new log, sequence 3625-SEP-13 07.38.44.996 AM +00 00 Checkpoint not complete25-SEP-13 07.38.44.996 AM +00 00 Current log# 1 seq# 35 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 07.38.48.065 AM +00 00 Thread 1 advanced to log sequence 36 (LGWR switch)25-SEP-13 07.38.48.065 AM +00 00 Current log# 2 seq# 36 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 07.38.48.146 AM +00 00 Archived Log entry 29 added for thread 1 sequence 35 ID 0x4ffec4be dest 1 25-SEP-13 07.43.51.838 AM +00 00 Thread 1 cannot allocate new log, sequence 3725-SEP-13 07.43.51.838 AM +00 00 Checkpoint not complete25-SEP-13 07.43.51.838 AM +00 00 Current log# 2 seq# 36 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 07.43.53.268 AM +00 00 System State dumped to trace file /rdsdbdata/log/diag/rdbms/orcl_a/ORCL/trace/ORCL_ora_9313_SYSTEMSTATE.trc25-SEP-13 07.43.55.015 AM +00 00 Thread 1 advanced to log sequence 37 (LGWR switch)25-SEP-13 07.43.55.015 AM +00 00 Current log# 3 seq# 37 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 07.43.55.137 AM +00 00 Archived Log entry 30 added for thread 1 sequence 36 ID 0x4ffec4be dest 1 25-SEP-13 07.48.56.649 AM +00 00 Thread 1 cannot allocate new log, sequence 3825-SEP-13 07.48.56.682 AM +00 00 Checkpoint not complete25-SEP-13 07.48.56.682 AM +00 00 Current log# 3 seq# 37 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log25-SEP-13 07.48.59.846 AM +00 00 Thread 1 advanced to log sequence 38 (LGWR switch)25-SEP-13 07.48.59.847 AM +00 00 Current log# 4 seq# 38 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log25-SEP-13 07.48.59.941 AM +00 00 Archived Log entry 31 added for thread 1 sequence 37 ID 0x4ffec4be dest 1 25-SEP-13 07.54.02.915 AM +00 00 Thread 1 advanced to log sequence 39 (LGWR switch)25-SEP-13 07.54.02.915 AM +00 00 Current log# 1 seq# 39 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 07.54.03.064 AM +00 00 Archived Log entry 32 added for thread 1 sequence 38 ID 0x4ffec4be dest 1 25-SEP-13 07.59.03.156 AM +00 00 Thread 1 cannot allocate new log, sequence 4025-SEP-13 07.59.03.156 AM +00 00 Checkpoint not complete25-SEP-13 07.59.03.156 AM +00 00 Current log# 1 seq# 39 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log25-SEP-13 07.59.06.285 AM +00 00 Thread 1 advanced to log sequence 40 (LGWR switch)25-SEP-13 07.59.06.285 AM +00 00 Current log# 2 seq# 40 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log25-SEP-13 07.59.06.384 AM +00 00 Archived Log entry 33 added for thread 1 sequence 39 ID 0x4ffec4be dest 1 25-SEP-13 08.04.08.439 AM +00 00 Thread 1 cannot allocate new log, sequence 41 25-SEP-13 08.04.08.439 AM +00 00 Checkpoint not complete 25-SEP-13 08.04.08.439 AM +00 00 Current log# 2 seq# 40 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log 25-SEP-13 08.04.11.591 AM +00 00 Thread 1 advanced to log sequence 41 (LGWR switch) 25-SEP-13 08.04.11.591 AM +00 00 Current log# 3 seq# 41 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log 25-SEP-13 08.04.11.748 AM +00 00 Archived Log entry 34 added for thread 1 sequence 40 ID 0x4ffec4be dest 1 25-SEP-13 08.09.13.491 AM +00 00 Thread 1 cannot allocate new log, sequence 42 25-SEP-13 08.09.13.491 AM +00 00 Checkpoint not complete 25-SEP-13 08.09.13.491 AM +00 00 Current log# 3 seq# 41 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log 25-SEP-13 08.09.16.706 AM +00 00 Thread 1 advanced to log sequence 42 (LGWR switch) 25-SEP-13 08.09.16.706 AM +00 00 Current log# 4 seq# 42 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log 25-SEP-13 08.09.16.822 AM +00 00 Archived Log entry 35 added for thread 1 sequence 41 ID 0x4ffec4be dest 1 25-SEP-13 08.13.23.835 AM +00 00 Starting ORACLE instance (normal) 25-SEP-13 08.13.24.337 AM +00 00 LICENSE_MAX_SESSION = 0 25-SEP-13 08.13.24.338 AM +00 00 LICENSE_SESSIONS_WARNING = 0 25-SEP-13 08.13.24.461 AM +00 00 Picked latch-free SCN scheme 3 25-SEP-13 08.13.24.632 AM +00 00 Autotune of undo retention is turned on. 25-SEP-13 08.13.24.637 AM +00 00 IMODE=BR 25-SEP-13 08.13.24.637 AM +00 00 ILAT =10 25-SEP-13 08.13.24.719 AM +00 00 LICENSE_MAX_USERS = 0 25-SEP-13 08.13.24.719 AM +00 00 SYS auditing is disabled 25-SEP-13 08.13.25.540 AM +00 00 Starting up 25-SEP-13 08.13.25.540 AM +00 00 Oracle Database 11g Release 11.2.0.2.0 - 64bit Production. 25-SEP-13 08.13.25.540 AM +00 00 Using parameter settings in server-side spfile /rdsdbbin/oracle/dbs/spfileORCL.ora 25-SEP-13 08.13.25.540 AM +00 00 WARNING there are one or more recursive spfile references which should be removed from /rdsdbbin/oracle/dbs/spfileORCL.ora 25-SEP-13 08.13.25.540 AM +00 00 System parameters with non-default values 25-SEP-13 08.13.25.541 AM +00 00 processes = 44 25-SEP-13 08.13.25.541 AM +00 00 spfile = /rdsdbbin/oracle/dbs/spfileORCL.ora 25-SEP-13 08.13.25.541 AM +00 00 filesystemio_options = setall 25-SEP-13 08.13.25.541 AM +00 00 memory_target = 312M 25-SEP-13 08.13.25.541 AM +00 00 memory_max_target = 312M 25-SEP-13 08.13.25.541 AM +00 00 control_files = /rdsdbdata/db/ORCL_A/controlfile/control-01.ctl 25-SEP-13 08.13.25.541 AM +00 00 log_archive_dest_1 = location= /rdsdbdata/db/ORCL_A/arch/redolog , valid_for=(ALL_LOGFILES,ALL_ROLES) 25-SEP-13 08.13.25.541 AM +00 00 log_archive_format = -%s-%t-%r.arc 25-SEP-13 08.13.25.541 AM +00 00 archive_lag_target = 300 25-SEP-13 08.13.25.542 AM +00 00 db_create_file_dest = /rdsdbdata/db 25-SEP-13 08.13.25.542 AM +00 00 db_recovery_file_dest_size= 1G 25-SEP-13 08.13.25.542 AM +00 00 standby_file_management = AUTO 25-SEP-13 08.13.25.542 AM +00 00 undo_tablespace = UNDO_T1 25-SEP-13 08.13.25.542 AM +00 00 db_block_checking = MEDIUM 25-SEP-13 08.13.25.542 AM +00 00 recyclebin = OFF 25-SEP-13 08.13.25.542 AM +00 00 local_listener = (ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) 25-SEP-13 08.13.25.542 AM +00 00 audit_file_dest = /rdsdbdata/admin/ORCL/adump 25-SEP-13 08.13.25.542 AM +00 00 db_name = ORCL 25-SEP-13 08.13.25.542 AM +00 00 db_unique_name = ORCL_A 25-SEP-13 08.13.25.543 AM +00 00 open_cursors = 300 25-SEP-13 08.13.25.543 AM +00 00 dg_broker_config_file1 = /rdsdbdata/config/dr1ORCL.dat 25-SEP-13 08.13.25.543 AM +00 00 dg_broker_config_file2 = /rdsdbdata/config/dr2ORCL.dat 25-SEP-13 08.13.25.543 AM +00 00 diagnostic_dest = /rdsdbdata/log 25-SEP-13 08.13.26.636 AM +00 00 PSP0 started with pid=3, OS id=8610 25-SEP-13 08.13.26.639 AM +00 00 PMON started with pid=2, OS id=8608 25-SEP-13 08.13.26.692 AM +00 00 VKTM started with pid=4, OS id=8612 25-SEP-13 08.13.26.695 AM +00 00 VKTM running at (100ms) precision 25-SEP-13 08.13.26.731 AM +00 00 GEN0 started with pid=5, OS id=8616 25-SEP-13 08.13.26.737 AM +00 00 DIAG started with pid=6, OS id=8618 25-SEP-13 08.13.26.762 AM +00 00 DBRM started with pid=7, OS id=8620 25-SEP-13 08.13.26.788 AM +00 00 DIA0 started with pid=8, OS id=8622 25-SEP-13 08.13.26.814 AM +00 00 MMAN started with pid=9, OS id=8624 25-SEP-13 08.13.26.849 AM +00 00 DBW0 started with pid=10, OS id=8626 25-SEP-13 08.13.26.875 AM +00 00 LGWR started with pid=11, OS id=8628 25-SEP-13 08.13.26.900 AM +00 00 CKPT started with pid=12, OS id=8630 25-SEP-13 08.13.26.925 AM +00 00 SMON started with pid=13, OS id=8632 25-SEP-13 08.13.26.955 AM +00 00 RECO started with pid=14, OS id=8634 25-SEP-13 08.13.26.981 AM +00 00 MMON started with pid=15, OS id=8636 25-SEP-13 08.13.27.007 AM +00 00 MMNL started with pid=16, OS id=8638 25-SEP-13 08.13.27.023 AM +00 00 ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment 25-SEP-13 08.13.27.169 AM +00 00 Spfile /rdsdbbin/oracle/dbs/spfileORCL.ora is in old pre-11 format and compatible = 11.0.0; converting to new H.A.R.D. compliant format. 25-SEP-13 08.13.27.948 AM +00 00 ALTER DATABASE MOUNT 25-SEP-13 08.13.32.825 AM +00 00 Successful mount of redo thread 1, with mount id 1354837543 25-SEP-13 08.13.32.848 AM +00 00 Database mounted in Exclusive Mode 25-SEP-13 08.13.32.848 AM +00 00 Lost write protection disabled 25-SEP-13 08.13.33.174 AM +00 00 Completed ALTER DATABASE MOUNT 25-SEP-13 08.13.33.488 AM +00 00 alter database end backup 25-SEP-13 08.13.33.538 AM +00 00 ORA-1142 signalled during alter database end backup... 25-SEP-13 08.13.34.446 AM +00 00 alter database archivelog 25-SEP-13 08.13.34.450 AM +00 00 Completed alter database archivelog 25-SEP-13 08.13.34.917 AM +00 00 alter database open 25-SEP-13 08.13.34.964 AM +00 00 Beginning crash recovery of 1 threads 25-SEP-13 08.13.35.014 AM +00 00 Started redo scan 25-SEP-13 08.13.35.314 AM +00 00 Completed redo scan 25-SEP-13 08.13.35.314 AM +00 00 read 282 KB redo, 77 data blocks need recovery 25-SEP-13 08.13.35.344 AM +00 00 Started redo application at 25-SEP-13 08.13.35.344 AM +00 00 Thread 1 logseq 40, block 2 25-SEP-13 08.13.35.492 AM +00 00 Recovery of Online Redo Log Thread 1 Group 2 Seq 40 Reading mem 0 25-SEP-13 08.13.35.492 AM +00 00 Mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log 25-SEP-13 08.13.35.567 AM +00 00 Recovery of Online Redo Log Thread 1 Group 3 Seq 41 Reading mem 0 25-SEP-13 08.13.35.567 AM +00 00 Mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log 25-SEP-13 08.13.35.582 AM +00 00 Recovery of Online Redo Log Thread 1 Group 4 Seq 42 Reading mem 0 25-SEP-13 08.13.35.582 AM +00 00 Mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log 25-SEP-13 08.13.35.583 AM +00 00 Completed redo application of 0.18MB 25-SEP-13 08.13.35.587 AM +00 00 Completed crash recovery at 25-SEP-13 08.13.35.587 AM +00 00 Thread 1 logseq 42, block 5, scn 247519 25-SEP-13 08.13.35.587 AM +00 00 77 data blocks read, 77 data blocks written, 282 redo k-bytes read 25-SEP-13 08.13.35.701 AM +00 00 LGWR STARTING ARCH PROCESSES 25-SEP-13 08.13.35.727 AM +00 00 ARC0 started with pid=18, OS id=8752 25-SEP-13 08.13.36.720 AM +00 00 ARC0 Archival started 25-SEP-13 08.13.36.720 AM +00 00 LGWR STARTING ARCH PROCESSES COMPLETE 25-SEP-13 08.13.36.721 AM +00 00 ARC0 STARTING ARCH PROCESSES 25-SEP-13 08.13.36.751 AM +00 00 ARC1 started with pid=19, OS id=8768 25-SEP-13 08.13.36.786 AM +00 00 ARC2 started with pid=20, OS id=8770 25-SEP-13 08.13.36.828 AM +00 00 ARC1 Archival started 25-SEP-13 08.13.36.828 AM +00 00 ARC2 Archival started 25-SEP-13 08.13.36.829 AM +00 00 ARC3 started with pid=21, OS id=8772 25-SEP-13 08.13.36.832 AM +00 00 ARC1 Becoming the no FAL ARCH 25-SEP-13 08.13.36.832 AM +00 00 ARC1 Becoming the no SRL ARCH 25-SEP-13 08.13.36.832 AM +00 00 Thread 1 advanced to log sequence 43 (thread open) 25-SEP-13 08.13.36.853 AM +00 00 ARC2 Becoming the heartbeat ARCH 25-SEP-13 08.13.36.862 AM +00 00 Thread 1 opened at log sequence 43 25-SEP-13 08.13.36.862 AM +00 00 Current log# 1 seq# 43 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log 25-SEP-13 08.13.36.862 AM +00 00 Successful open of redo thread 1 25-SEP-13 08.13.36.937 AM +00 00 SMON enabling cache recovery 25-SEP-13 08.13.36.977 AM +00 00 Archived Log entry 36 added for thread 1 sequence 42 ID 0x4ffec4be dest 1 25-SEP-13 08.13.37.823 AM +00 00 ARC3 Archival started 25-SEP-13 08.13.37.823 AM +00 00 ARC0 STARTING ARCH PROCESSES COMPLETE 25-SEP-13 08.13.37.844 AM +00 00 [8750] Successfully onlined Undo Tablespace 2. 25-SEP-13 08.13.37.845 AM +00 00 Undo initialization finished serial 0 start 3019526 end 3019846 diff 320 (3 seconds) 25-SEP-13 08.13.37.845 AM +00 00 Verifying file header compatibility for 11g tablespace encryption.. 25-SEP-13 08.13.37.846 AM +00 00 Verifying 11g file header compatibility for tablespace encryption completed 25-SEP-13 08.13.37.846 AM +00 00 SMON enabling tx recovery 25-SEP-13 08.13.37.876 AM +00 00 Database Characterset is AL32UTF8 25-SEP-13 08.13.38.493 AM +00 00 No Resource Manager plan active 25-SEP-13 08.13.39.033 AM +00 00 replication_dependency_tracking turned off (no async multimaster replication found) 25-SEP-13 08.13.40.058 AM +00 00 Starting background process QMNC 25-SEP-13 08.13.40.085 AM +00 00 QMNC started with pid=22, OS id=8788 25-SEP-13 08.13.41.007 AM +00 00 Completed alter database open 25-SEP-13 08.18.31.251 AM +00 00 Thread 1 advanced to log sequence 44 (LGWR switch) 25-SEP-13 08.18.31.251 AM +00 00 Current log# 2 seq# 44 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log 25-SEP-13 08.18.31.349 AM +00 00 Archived Log entry 37 added for thread 1 sequence 43 ID 0x4ffec4be dest 1 25-SEP-13 08.18.40.502 AM +00 00 Starting background process SMCO 25-SEP-13 08.18.40.528 AM +00 00 SMCO started with pid=26, OS id=10196 25-SEP-13 08.23.32.642 AM +00 00 Thread 1 advanced to log sequence 45 (LGWR switch) 25-SEP-13 08.23.32.642 AM +00 00 Current log# 3 seq# 45 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log 25-SEP-13 08.23.32.763 AM +00 00 Archived Log entry 38 added for thread 1 sequence 44 ID 0x4ffec4be dest 1 25-SEP-13 08.28.31.742 AM +00 00 Thread 1 advanced to log sequence 46 (LGWR switch) 25-SEP-13 08.28.31.742 AM +00 00 Current log# 4 seq# 46 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log 25-SEP-13 08.28.31.831 AM +00 00 Archived Log entry 39 added for thread 1 sequence 45 ID 0x4ffec4be dest 1 25-SEP-13 08.33.31.028 AM +00 00 Thread 1 cannot allocate new log, sequence 47 25-SEP-13 08.33.31.040 AM +00 00 Checkpoint not complete 25-SEP-13 08.33.31.040 AM +00 00 Current log# 4 seq# 46 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_4_8r2sbtx5_.log 25-SEP-13 08.33.34.228 AM +00 00 Thread 1 advanced to log sequence 47 (LGWR switch) 25-SEP-13 08.33.34.229 AM +00 00 Current log# 1 seq# 47 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_1_8r2sbrg1_.log 25-SEP-13 08.33.34.375 AM +00 00 Archived Log entry 40 added for thread 1 sequence 46 ID 0x4ffec4be dest 1 25-SEP-13 08.38.36.903 AM +00 00 Thread 1 advanced to log sequence 48 (LGWR switch) 25-SEP-13 08.38.36.903 AM +00 00 Current log# 2 seq# 48 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_2_8r2sbor6_.log 25-SEP-13 08.38.36.990 AM +00 00 Archived Log entry 41 added for thread 1 sequence 47 ID 0x4ffec4be dest 1 25-SEP-13 08.43.39.068 AM +00 00 Thread 1 advanced to log sequence 49 (LGWR switch) 25-SEP-13 08.43.39.068 AM +00 00 Current log# 3 seq# 49 mem# 0 /rdsdbdata/db/ORCL_A/onlinelog/o1_mf_3_8r2sbm31_.log 25-SEP-13 08.43.39.219 AM +00 00 Archived Log entry 42 added for thread 1 sequence 48 ID 0x4ffec4be dest 1